package top.xuwuqiang.study.jacawebjdbc.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DBHelper {
    /* com.mysql.cj.jdbc.Driver*/
    public static final String URL="jdbc:mysql://teach_mysql.huhuiyu.top:31000/db_xuwuqiang?useUnicode=true&characterEncoding=utf8&characterSetResults=utf8&useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai";
    public static final String USER="db_xuwuqiang";
    public static final String PASSWORD="2580134679xwq";

    public static final String DRIVER="com.mysql.cj.jdbc.Driver";

    static {
        try {
            Class.forName(DRIVER);
        } catch (ClassNotFoundException e) {
            throw new RuntimeException(e);
        }

    }

    public static Connection getConnection(){
        try {
            return DriverManager.getConnection(URL,USER,PASSWORD);
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
    }


}

